package com.example.project.dao.sqls;

import org.apache.ibatis.jdbc.SQL;

/**
 * Created by Ethan on 2022-08-25 22:08
 */
public class TableCProvider {
    public String findAllSql() {
        return new SQL()
                .SELECT("*")
                .FROM("c")
                .toString();
    }

    public String findSql(final String s) {
        return new SQL()
                .SELECT("*")
                .FROM("c")
                .WHERE("B like " + s)
                .toString();
    }

    public String insertSql() {
        return new SQL()
                .INSERT_INTO("c")
                .VALUES("B,aaS,bbS,ccS,aaA,bbA,ccA,aaSS,aaC,ddS",
                        "#{b},#{aaS},#{bbS},#{ccS},#{aaA},#{bbA},#{ccA},#{aaSS},#{aaC},#{ddS}")
                .toString();
    }
}
